Hệ thống quản lý cửa hàng thú cưng bằng PHP

9.446 lượt xem;

deletephone.php
source code /
project /

1
2 <html>
3 <head>
4         <title>Customer </title>
5         <style>
6             body {
7   margin: 0;
8   font-family: Arial, Helvetica, sans-serif;
9   background: #484848;
10 }
11 .topnav {
12   overflow: hidden;
13   background-color:#8d2663;
14   height: 70px;
15   border: 3px solid #b40a70;
16 }
17
18 .topnav a {
19   float: left;
20   color: #f2f2f2;
21   text-align: center;
22   padding: 14px 16px;
23   text-decoration: none;
24   font-size: 35px;
25   font-weight: bold;
26 }
27 </style>
28
29     <body>
30     <div class="topnav">
31             <a class="active" href="home.html"><img src="ic_add_pet.png"></a>
32             <a href="customer.php">Customers</a>
33
34           </div>
35         <?php
36
37 $servername = "localhost";
38 $username = "root";
39 $password = "";
40 $dbname = "Petshop_management";
41
42 // Create connection
43 $conn = new mysqli($servername, $username, $password, $dbname);
44 // Check connection
45 if ($conn->connect_error) {
46     die("Connection failed: " . $conn->connect_error);
47 }
48 //echo " CONNECTION ESTABLISHED \r\n";
49 //echo " INSERTION IN PROCESS";
50 $cs_id=$_POST["t1"];
51 $phone=$_POST["t2"];
52 $Query2="select count(*) from phone where cs_id='$cs_id' AND cs_phone='$phone'";
53 $Execute = mysqli_query($conn,$Query2);
54 $count = mysqli_fetch_row($Execute);
55 if($count[0]==1)
56 {
57   $sql = "DELETE FROM phone WHERE cs_id='$cs_id' AND cs_phone='$phone'";
58 if ($conn->query($sql) == TRUE) {
59     echo '<div>
60     <h1 style="color:#f2f2f2;font-size:50px; font-family: "Roboto", sans-serif;margin:auto;">Data deleted successfully</h1>
61        </div>';
62 } else {
63     echo "Error: " . $sql . "<br>" . $conn->error;
64 }
65
66 }
67 else{
68   echo '<div>
69   <h1 style="color:#f2f2f2;font-size:40px; font-family: "Roboto", sans-serif;margin:auto;"> Data not found</h1>
70      </div>';
71 }
72
73 $conn->close();
74 ?>
75 <form>
76        <button type="submit" style="height: 50px;width: 150px;cursor:pointer;border-radius:15px;
77 border: 3px solid #b40a70;background-color: #8d2663;color:#f2f2f2;font-size:15px;"formaction="phone.php">back</button>
78 </form>
79 </body>
80 </html>